<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Release 7.3.3</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.1.2 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="Release Notes"
HREF="release.html"><LINK
REL="PREVIOUS"
TITLE="Release 7.3.4"
HREF="release-7-3-4.html"><LINK
REL="NEXT"
TITLE="Release 7.3.2"
HREF="release-7-3-2.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2011-12-01T22:07:59"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.1.2 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="Release 7.3.4"
HREF="release-7-3-4.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="release.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Appendix E. Release Notes</TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="Release 7.3.2"
HREF="release-7-3-2.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="RELEASE-7-3-3"
>E.164. Release 7.3.3</A
></H1
><DIV
CLASS="NOTE"
><BLOCKQUOTE
CLASS="NOTE"
><P
><B
>Release Date: </B
>2003-05-22</P
></BLOCKQUOTE
></DIV
><P
>  This release contains a variety of fixes for version 7.3.2.
 </P
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN127337"
>E.164.1. Migration to Version 7.3.3</A
></H2
><P
>   A dump/restore is <SPAN
CLASS="emphasis"
><I
CLASS="EMPHASIS"
>not</I
></SPAN
> required for those
   running version 7.3.*.
  </P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN127341"
>E.164.2. Changes</A
></H2
><P
></P
><UL
><LI
><P
>Repair sometimes-incorrect computation of StartUpID after a crash</P
></LI
><LI
><P
>Avoid slowness with lots of deferred triggers in one transaction (Stephan)</P
></LI
><LI
><P
>Don't lock referenced row when <TT
CLASS="COMMAND"
>UPDATE</TT
> doesn't change foreign key's value (Jan)</P
></LI
><LI
><P
>Use <TT
CLASS="COMMAND"
>-fPIC</TT
> not <TT
CLASS="COMMAND"
>-fpic</TT
> on Sparc (Tom Callaway)</P
></LI
><LI
><P
>Repair lack of schema-awareness in contrib/reindexdb</P
></LI
><LI
><P
>Fix contrib/intarray error for zero-element result array (Teodor)</P
></LI
><LI
><P
>Ensure createuser script will exit on control-C (Oliver)</P
></LI
><LI
><P
>Fix errors when the type of a dropped column has itself been dropped</P
></LI
><LI
><P
><TT
CLASS="COMMAND"
>CHECKPOINT</TT
> does not cause database panic on failure in noncritical steps</P
></LI
><LI
><P
>Accept 60 in seconds fields of timestamp, time, interval input values</P
></LI
><LI
><P
>Issue notice, not error, if <TT
CLASS="TYPE"
>TIMESTAMP</TT
>,
<TT
CLASS="TYPE"
> TIME</TT
>, or <TT
CLASS="TYPE"
>INTERVAL</TT
> precision too large</P
></LI
><LI
><P
>Fix <CODE
CLASS="FUNCTION"
>abstime-to-time</CODE
> cast function (fix is
      not applied unless you <SPAN
CLASS="APPLICATION"
>initdb</SPAN
>)</P
></LI
><LI
><P
>Fix <SPAN
CLASS="APPLICATION"
>pg_proc</SPAN
> entry for
     <TT
CLASS="TYPE"
>timestampt_izone</TT
> (fix is not applied unless you
       <SPAN
CLASS="APPLICATION"
>initdb</SPAN
>)</P
></LI
><LI
><P
>Make <CODE
CLASS="FUNCTION"
>EXTRACT(EPOCH FROM timestamp without time zone)</CODE
> treat input as local time</P
></LI
><LI
><P
><TT
CLASS="COMMAND"
>'now'::timestamptz</TT
> gave wrong answer if timezone changed earlier in transaction</P
></LI
><LI
><P
><TT
CLASS="ENVAR"
>HAVE_INT64_TIMESTAMP</TT
> code for time with timezone overwrote its input</P
></LI
><LI
><P
>Accept <TT
CLASS="COMMAND"
>GLOBAL TEMP/TEMPORARY</TT
> as a
      synonym for <TT
CLASS="COMMAND"
>TEMPORARY</TT
></P
></LI
><LI
><P
>Avoid improper schema-privilege-check failure in foreign-key triggers</P
></LI
><LI
><P
>Fix bugs in foreign-key triggers for <TT
CLASS="COMMAND"
>SET DEFAULT</TT
> action</P
></LI
><LI
><P
>Fix incorrect time-qual check in row fetch for
      <TT
CLASS="COMMAND"
>UPDATE</TT
> and <TT
CLASS="COMMAND"
>DELETE</TT
> triggers</P
></LI
><LI
><P
>Foreign-key clauses were parsed but ignored in
      <TT
CLASS="COMMAND"
>ALTER TABLE ADD COLUMN</TT
></P
></LI
><LI
><P
>Fix createlang script breakage for case where handler function already exists</P
></LI
><LI
><P
>Fix misbehavior on zero-column tables in <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
>, COPY, ANALYZE, other places</P
></LI
><LI
><P
>Fix misbehavior of <CODE
CLASS="FUNCTION"
>func_error()</CODE
> on type names containing '%'</P
></LI
><LI
><P
>Fix misbehavior of <CODE
CLASS="FUNCTION"
>replace()</CODE
> on strings containing '%'</P
></LI
><LI
><P
>Regular-expression patterns containing certain multibyte characters failed</P
></LI
><LI
><P
>Account correctly for <TT
CLASS="COMMAND"
>NULL</TT
>s in more cases in join size estimation</P
></LI
><LI
><P
>Avoid conflict with system definition of <CODE
CLASS="FUNCTION"
>isblank()</CODE
> function or macro</P
></LI
><LI
><P
>Fix failure to convert large code point values in EUC_TW conversions (Tatsuo)</P
></LI
><LI
><P
>Fix error recovery for <CODE
CLASS="FUNCTION"
>SSL_read</CODE
>/<CODE
CLASS="FUNCTION"
>SSL_write</CODE
> calls</P
></LI
><LI
><P
>Don't do early constant-folding of type coercion expressions</P
></LI
><LI
><P
>Validate page header fields immediately after reading in any page</P
></LI
><LI
><P
>Repair incorrect check for ungrouped variables in unnamed joins</P
></LI
><LI
><P
>Fix buffer overrun in <CODE
CLASS="FUNCTION"
>to_ascii</CODE
> (Guido Notari)</P
></LI
><LI
><P
>contrib/ltree fixes (Teodor)</P
></LI
><LI
><P
>Fix core dump in deadlock detection on machines where char is unsigned</P
></LI
><LI
><P
>Avoid running out of buffers in many-way indexscan (bug introduced in 7.3)</P
></LI
><LI
><P
>Fix planner's selectivity estimation functions to handle domains properly</P
></LI
><LI
><P
>Fix <SPAN
CLASS="APPLICATION"
>dbmirror</SPAN
> memory-allocation bug (Steven Singer)</P
></LI
><LI
><P
>Prevent infinite loop in <CODE
CLASS="FUNCTION"
>ln(numeric)</CODE
> due to roundoff error</P
></LI
><LI
><P
><TT
CLASS="COMMAND"
>GROUP BY</TT
> got confused if there were multiple equal GROUP BY items</P
></LI
><LI
><P
>Fix bad plan when inherited <TT
CLASS="COMMAND"
>UPDATE</TT
>/<TT
CLASS="COMMAND"
>DELETE</TT
> references another inherited table</P
></LI
><LI
><P
>Prevent clustering on incomplete (partial or non-NULL-storing) indexes</P
></LI
><LI
><P
>Service shutdown request at proper time if it arrives while still starting up</P
></LI
><LI
><P
>Fix left-links in temporary indexes (could make backwards scans miss entries)</P
></LI
><LI
><P
>Fix incorrect handling of client_encoding setting in postgresql.conf (Tatsuo)</P
></LI
><LI
><P
>Fix failure to respond to <TT
CLASS="COMMAND"
>pg_ctl stop -m fast</TT
> after Async_NotifyHandler runs</P
></LI
><LI
><P
>Fix SPI for case where rule contains multiple statements of the same type</P
></LI
><LI
><P
>Fix problem with checking for wrong type of access privilege in rule query</P
></LI
><LI
><P
>Fix problem with <TT
CLASS="COMMAND"
>EXCEPT</TT
> in <TT
CLASS="COMMAND"
>CREATE RULE</TT
></P
></LI
><LI
><P
>Prevent problem with dropping temp tables having serial columns</P
></LI
><LI
><P
>Fix replace_vars_with_subplan_refs failure in complex views</P
></LI
><LI
><P
>Fix regexp slowness in single-byte encodings (Tatsuo)</P
></LI
><LI
><P
>Allow qualified type names in <TT
CLASS="COMMAND"
>CREATE CAST</TT
>
      and <TT
CLASS="COMMAND"
> DROP CAST</TT
></P
></LI
><LI
><P
>Accept <CODE
CLASS="FUNCTION"
>SETOF type[]</CODE
>, which formerly had to
      be written <CODE
CLASS="FUNCTION"
>SETOF _type</CODE
></P
></LI
><LI
><P
>Fix <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
> core dump in some cases with procedural languages</P
></LI
><LI
><P
>Force ISO datestyle in <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
> output, for portability (Oliver)</P
></LI
><LI
><P
><SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
> failed to handle error return
      from <CODE
CLASS="FUNCTION"
>lo_read</CODE
> (Oleg Drokin)</P
></LI
><LI
><P
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> failed with groups having no members (Nick Eskelinen)</P
></LI
><LI
><P
><SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> failed to recognize --globals-only switch</P
></LI
><LI
><P
>pg_restore failed to restore blobs if -X disable-triggers is specified</P
></LI
><LI
><P
>Repair intrafunction memory leak in plpgsql</P
></LI
><LI
><P
>pltcl's <TT
CLASS="COMMAND"
>elog</TT
> command dumped core if given wrong parameters (Ian Harding)</P
></LI
><LI
><P
>plpython used wrong value of <TT
CLASS="ENVAR"
>atttypmod</TT
> (Brad McLean)</P
></LI
><LI
><P
>Fix improper quoting of boolean values in Python interface (D'Arcy)</P
></LI
><LI
><P
>Added <CODE
CLASS="FUNCTION"
>addDataType()</CODE
> method to PGConnection interface for JDBC</P
></LI
><LI
><P
>Fixed various problems with updateable ResultSets for JDBC (Shawn Green)</P
></LI
><LI
><P
>Fixed various problems with DatabaseMetaData for JDBC (Kris Jurka, Peter Royal)</P
></LI
><LI
><P
>Fixed problem with parsing table ACLs in JDBC</P
></LI
><LI
><P
>Better error message for character set conversion problems in JDBC</P
></LI
></UL
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="release-7-3-4.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="release-7-3-2.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Release 7.3.4</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="release.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Release 7.3.2</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>